﻿using System;using ERP_RORZE_SYSTEM;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace ERP_RORZE_DLL.Product.database
{
    public class ClsMachineWTSTable
    {
        #region Members
        protected int iD;
        protected DateTime date;
        protected string shift;
        protected string machineID;
        protected string staffID;
        protected string mONo;
        protected string optionID;
        protected string workID;
        protected double time;
        protected int oKQty;
        protected int nGQty;
        protected double proTime;
        protected double clampTime;
        protected string note1;
        protected string note2;
        protected string from;
        protected string to;
        protected double sProTime;
        protected double sClampTime;
        protected int tOKQty;
        protected int tNGQty;
        #endregion
        #region Public Properties

        /// <summary>
        /// Property relating to database column ID(int,not null)
        /// </summary>
        public int ID
        {
            get { return iD; }
            set { iD = value; }
        }

        /// <summary>
        /// Property relating to database column date(datetime,null)
        /// </summary>
        public DateTime Date
        {
            get { return date; }
            set { date = value; }
        }

        /// <summary>
        /// Property relating to database column Shift(nvarchar(250),null)
        /// </summary>
        public string Shift
        {
            get { return shift; }
            set { shift = value; }
        }

        /// <summary>
        /// Property relating to database column MachineID(nvarchar(50),null)
        /// </summary>
        public string MachineID
        {
            get { return machineID; }
            set { machineID = value; }
        }

        /// <summary>
        /// Property relating to database column StaffID(nvarchar(50),null)
        /// </summary>
        public string StaffID
        {
            get { return staffID; }
            set { staffID = value; }
        }

        /// <summary>
        /// Property relating to database column MONo(nvarchar(50),null)
        /// </summary>
        public string MONo
        {
            get { return mONo; }
            set { mONo = value; }
        }

        /// <summary>
        /// Property relating to database column OptionID(nvarchar(50),null)
        /// </summary>
        public string OptionID
        {
            get { return optionID; }
            set { optionID = value; }
        }

        /// <summary>
        /// Property relating to database column WorkID(nvarchar(50),null)
        /// </summary>
        public string WorkID
        {
            get { return workID; }
            set { workID = value; }
        }

        /// <summary>
        /// Property relating to database column Time(float,null)
        /// </summary>
        public double Time
        {
            get { return time; }
            set { time = value; }
        }

        /// <summary>
        /// Property relating to database column OKQty(int,null)
        /// </summary>
        public int OKQty
        {
            get { return oKQty; }
            set { oKQty = value; }
        }

        /// <summary>
        /// Property relating to database column NGQty(int,null)
        /// </summary>
        public int NGQty
        {
            get { return nGQty; }
            set { nGQty = value; }
        }

        /// <summary>
        /// Property relating to database column ProTime(float,null)
        /// </summary>
        public double ProTime
        {
            get { return proTime; }
            set { proTime = value; }
        }

        /// <summary>
        /// Property relating to database column ClampTime(float,null)
        /// </summary>
        public double ClampTime
        {
            get { return clampTime; }
            set { clampTime = value; }
        }

        /// <summary>
        /// Property relating to database column Note1(nvarchar(250),null)
        /// </summary>
        public string Note1
        {
            get { return note1; }
            set { note1 = value; }
        }

        /// <summary>
        /// Property relating to database column Note2(nvarchar(250),null)
        /// </summary>
        public string Note2
        {
            get { return note2; }
            set { note2 = value; }
        }

        /// <summary>
        /// Property relating to database column From(nvarchar(50),null)
        /// </summary>
        public string From
        {
            get { return from; }
            set { from = value; }
        }

        /// <summary>
        /// Property relating to database column to(nvarchar(50),null)
        /// </summary>
        public string To
        {
            get { return to; }
            set { to = value; }
        }

        /// <summary>
        /// Property relating to database column SProTime(float,null)
        /// </summary>
        public double SProTime
        {
            get { return sProTime; }
            set { sProTime = value; }
        }

        /// <summary>
        /// Property relating to database column SClampTime(float,null)
        /// </summary>
        public double SClampTime
        {
            get { return sClampTime; }
            set { sClampTime = value; }
        }

        /// <summary>
        /// Property relating to database column TOKQty(int,null)
        /// </summary>
        public int TOKQty
        {
            get { return tOKQty; }
            set { tOKQty = value; }
        }

        /// <summary>
        /// Property relating to database column TNGQty(int,null)
        /// </summary>
        public int TNGQty
        {
            get { return tNGQty; }
            set { tNGQty = value; }
        }
        #endregion

    }
}
